Search results

Refine by learning area


Refine by topic

Main topic Specific topic Related topic
Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Online

Creating my own spreadsheet to convert binary to decimal

A spreadsheet can be used to do calculations quickly using formulas. How can we make a spreadsheet that converts a binary number to a decimal number? This lesson provides some guidance and Excel files for student and teacher use.

Online

reSolve: Sport Stats

In this lesson, students examine sporting scores and explore the concept of the average of a set of scores. Students collect sporting scores from real and hypothetical games, use blocks to visualise an even distribution of scores across matches and then explore how to calculate the average of a set of scores. The lesson ...

Online

reSolve: Measurement - Jump!

In this sequence of two lessons, students investigate how far they can jump and explore the jumping distance of a range of animals. Students first estimate the distance they can jump, then undertake an investigation by jumping using a range of techniques. Class data is recorded and displayed and students compare their jumping ...

Online

reSolve: Authentic Problems: Bottle Flipping

This sequence of four lessons explores fractions and statistical reasoning through conducting a series of fair tests to answer the question 'What fraction of a bottle needs to be filled with water to be the best for bottle flipping?'. The lessons focus on building understanding of fractions and collecting, organising and ...

Online

reSolve: Statistics - Licorice Lines

This sequence of two lessons explores the concept of statistical variation. Students make licorice logs both by hand and by using a Play Doh machine. They record and compare the attributes of both types of licorice by plotting their findings and comparing the shapes of the two plots. Students are then challenged to produce ...

Online

TIMES Module 22: Number and Algebra: consumer arithmetic - teacher guide

This is a 23-page guide for teachers, providing an introduction to the financial mathematics component of the number and algebra strands for years 9 and 10. A brief history of the concept of money concludes the module.

Online

TIMES Module 2: Statistics and Probability: data investigation and interpretation, year 4 - teacher guide

This is a 13-page guide for teachers. It continues the development of probability. An informal consideration of outcomes is undertaken.

Online

The First Fleet - dataset collections

The dataset provides information about 780 of the convicts transported to Australia on the First Fleet ships 'Alexander', 'Charlotte', 'Lady Penrhyn', 'Friendship', 'Prince of Wales' and 'Scarborough' in 1788. The dataset includes information on items such as the convict's name, occupation, crime, date of trial and term ...

Online

MoneySmart: Sal's secret

This is a year 3 mathematics unit of work about saving and budgeting for a class party. The unit is intended to take about 10.5 hours of teaching and learning time spread over some months. It consists of nine student activities supported by teacher notes on curriculum, pedagogy and assessment. Student activities include ...

Online

MoneySmart: The house of needs and wants

This is a unit of work integrating aspects of the mathematics, English and science curriculums around planning a school breakfast. The unit was written for year 3 and is intended to take about 12 hours. It consists of 11 student activities supported by teacher notes on curriculum, pedagogy and assessment. Student activities ...

Online

Rubbish recording and reduction: Part 2

In this lesson sequence students use Excel to represent data in a variety of ways.

Online

MoneySmart: Advertising detectives

In ASIC's MoneySmart Teaching Advertising detectives students will become detectives in a bid to help solve an alarming case of advertisements influencing children to buy or want a product. Students will investigate the different gimmicks/tricks used in advertising, how they target children and how their effect can be minimised. ...

Online

Rubbish recording and reduction: Part 1

In this lesson sequence students survey and collect data concerning what is brought to school each day and subsequently becomes rubbish. They then use Excel to represent that data in a variety of different ways.

Online

Determining the probability of a good day for sowing cotton

This activity is a series of three related tasks that support the use of spreadsheets (Excel), Venn diagrams and two-way tables to develop an understanding of conditional probability when used to determine the probability of a farmer being able to sow a cotton crop. The activity is, based on real historical soil and air ...